Tabela WHInpatient

Definicja tabeli WHInpatient

Name

WHInpatient

Code

WHInpatient

Comment

 


Lista kolumn tabeli WHInpatient

Name

Code

FullDT

FullDT

InpatientsCount

InpatientsCount

InpatientsCount7D

InpatientsCount7D

InpatientsCount30D

InpatientsCount30D

InpatientsCountThisMonth

InpatientsCountThisMonth

InpatientsCountThisYear

InpatientsCountThisYear

MandaysCount

MandaysCount

MandaysIncrease

MandaysIncrease

MandaysIncreaseYear

MandaysIncreaseYear


Kolumna FullDT tabeli WHInpatient

Definicja kolumny FullDT tabeli WHInpatient

Name

FullDT

Code

FullDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna InpatientsCount tabeli WHInpatient

Definicja kolumny InpatientsCount tabeli WHInpatient

Name

InpatientsCount

Code

InpatientsCount

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InpatientsCount7D tabeli WHInpatient

Definicja kolumny InpatientsCount7D tabeli WHInpatient

Name

InpatientsCount7D

Code

InpatientsCount7D

Data Type

FLOAT

Mandatory

No

Comment

 


Kolumna InpatientsCount30D tabeli WHInpatient

Definicja kolumny InpatientsCount30D tabeli WHInpatient

Name

InpatientsCount30D

Code

InpatientsCount30D

Data Type

FLOAT

Mandatory

No

Comment

 


Kolumna InpatientsCountThisMonth tabeli WHInpatient

Definicja kolumny InpatientsCountThisMonth tabeli WHInpatient

Name

InpatientsCountThisMonth

Code

InpatientsCountThisMonth

Data Type

FLOAT

Mandatory

No

Comment

 


Kolumna InpatientsCountThisYear tabeli WHInpatient

Definicja kolumny InpatientsCountThisYear tabeli WHInpatient

Name

InpatientsCountThisYear

Code

InpatientsCountThisYear

Data Type

FLOAT

Mandatory

No

Comment

 


Kolumna MandaysCount tabeli WHInpatient

Definicja kolumny MandaysCount tabeli WHInpatient

Name

MandaysCount

Code

MandaysCount

Data Type

NUMBER(10)

Mandatory

No

Comment

Zsumowana na dany miesiac liczba osobodni


Kolumna MandaysIncrease tabeli WHInpatient

Definicja kolumny MandaysIncrease tabeli WHInpatient

Name

MandaysIncrease

Code

MandaysIncrease

Data Type

NUMBER(10)

Mandatory

No

Comment

Liczbe osobodni, liczona w sposób przyrostowy


Kolumna MandaysIncreaseYear tabeli WHInpatient

Definicja kolumny MandaysIncreaseYear tabeli WHInpatient

Name

MandaysIncreaseYear

Code

MandaysIncreaseYear

Data Type

NUMBER(10)

Mandatory

No

Comment

Roczny przyrost osobodni


Lista kluczy tabeli WHInpatient

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli WHInpatient

Definicja klucza Identifier_1 tabeli WHInpatient

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment